package xyz.labmem.main.modular.app.gmjj.mapper;

import org.apache.ibatis.annotations.Select
import org.springframework.stereotype.Repository
import xyz.labmem.main.modular.app.gmjj.entity.sub.JyzcjbSub
import xyz.labmem.main.modular.common.mapper.AppBaseMapper

/**
 * 加油站采集_子Mapper接口
 *
 * @author ruoyi
 * @date 2022-03-08
 */
@Repository
interface JyzcjbSub_Mapper : AppBaseMapper<JyzcjbSub>{

    @Select("select ypmc,sum(kfkcld) kfkcld from jyzcjb_sub where pk_id = #{pkId} GROUP BY ypmc order by ypmc desc")  //where tbrq like concat('#{date}, '%')
    fun selectChart(pkId : String) : ArrayList<JyzcjbSub>
}
